home *** CD-ROM | disk | FTP | other *** search
- Problem A 1 year financial modeling system for a project oriented
- company that needs to be able to evaluate the impact of a
- decision made at a detail level, on the overall company's
- short term financial picture.
- _________________________________
- Block | |
- Diagram | Table of Contents | Tips: Bottomline Summary
- |---------------------------------| technique of
- | Global Assumptions | extracting key #'s
- |---------------------------------| from schedules
- | Bottomline Summary | throughout the
- |---------------------------------| model into one
- | Income Statement | centralized area
- |---------------------------------| for doing what-if
- | Sales by project | analysis (A68)
- |---------------------------------|
- | Gross Margins by Project | Printing and Goto
- |---------------------------------| macros activated by
- | Selling Expenses | pressing F7 key
- |---------------------------------| twice.
- | G & A - Supporting Schedules |
- |---------------------------------|
- | Cash Flow Projections |
- |---------------------------------|
- | Schedule of A/R collections |
- |---------------------------------|
- | COGS Analysis |
- |---------------------------------|
- | COGS Supporting Schedules |
- |---------------------------------|
- | Balance Sheet |
- |---------------------------------|
- | Ratio Analysis |
- |---------------------------------|
- | Macros |
- |---------------------------------|
-
-